| department                                                                                    |
 +-----------------------------------------------+--------+------------------------+-------------+
 | school                                        |        |                        |             |
 +------+-------------------------------+--------+        |                        |             |
 | code | name                          | campus | code   | name                   | school_code |
-+------+-------------------------------+--------+--------+------------------------+-------------+-
 | bus  | School of Business            | south  | acc    | Accounting             | bus         |
 | art  | School of Art & Design        | old    | arthis | Art History            | art         |
 | ns   | School of Natural Sciences    | old    | astro  | Astronomy              | ns          |
 | eng  | School of Engineering         | north  | be     | Bioengineering         | eng         |
 :      :                               :        | bursar | Bursar's Office        |             |
 :      :                               :        | career | Career Development     |             |
 | ns   | School of Natural Sciences    | old    | chem   | Chemistry              | ns          |
 | eng  | School of Engineering         | north  | comp   | Computer Science       | eng         |
 | bus  | School of Business            | south  | econ   | Economics              | bus         |
 | edu  | College of Education          | old    | edpol  | Educational Policy     | edu         |
 | eng  | School of Engineering         | north  | ee     | Electrical Engineering | eng         |
 | la   | School of Arts and Humanities | old    | eng    | English                | la          |
 | la   | School of Arts and Humanities | old    | hist   | History                | la          |
 | la   | School of Arts and Humanities | old    | lang   | Foreign Languages      | la          |
 | eng  | School of Engineering         | north  | me     | Mechanical Engineering | eng         |
 | bus  | School of Business            | south  | mm     | Management & Marketing | bus         |
 | ns   | School of Natural Sciences    | old    | mth    | Mathematics            | ns          |
 :      :                               :        | parent | Parents & Alumni       |             |
 | ns   | School of Natural Sciences    | old    | phys   | Physics                | ns          |
 | mus  | School of Music & Dance       | south  | pia    | Piano                  | mus         |
 | la   | School of Arts and Humanities | old    | poli   | Political Science      | la          |
 | la   | School of Arts and Humanities | old    | psych  | Psychology             | la          |
 | art  | School of Art & Design        | old    | stdart | Studio Art             | art         |
 | mus  | School of Music & Dance       | south  | str    | Strings                | mus         |
 | edu  | College of Education          | old    | tched  | Teacher Education      | edu         |
 | mus  | School of Music & Dance       | south  | voc    | Vocals                 | mus         |
 | mus  | School of Music & Dance       | south  | win    | Wind                   | mus         |